Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
SID NUMBER(38) No null 1 null NO NO NO
PARTIC_OBJ VARCHAR2(20) Yes null 2 null NO NO NO
PARTICIPANT_DISPLAY VARCHAR2(20) Yes null 3 null NO NO NO
FILE_CONTEXT VARCHAR2(400) Yes null 4 null NO NO NO
OWNING_UNIT VARCHAR2(400) Yes null 5 null NO NO NO
LEAD_DISPLAY VARCHAR2(400) Yes null 6 null NO NO NO
OUTCOME VARCHAR2(4000) Yes null 7 null NO NO NO
OUTCOME_SUBCATEGORY VARCHAR2(4000) Yes null 8 null NO NO NO
OFFICE VARCHAR2(4000) Yes null 9 null NO NO NO
START_DATE DATE Yes null 10 null NO NO NO
END_DATE DATE Yes null 11 null NO NO NO
EMPLOYEE_TYPE VARCHAR2(4000) Yes null 12 null NO NO NO
CREATED_BY VARCHAR2(100) Yes null 13 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CUBE_PARTIC_OUTCOMES_INTERCOMS VIEW QART V_CUBE_INDIV_PARTIC_OUTCOMES VIEW



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CUBE_INDIV_PARTIC_OUTCOMES VIEW QART MV_ACM_OBJ TABLE
QART V_CUBE_INDIV_PARTIC_OUTCOMES VIEW QART MV_ACM_REFERENCE TABLE
QART V_CUBE_INDIV_PARTIC_OUTCOMES VIEW QART MV_PARTIC_INDIV_OFFICE TABLE
QART V_CUBE_INDIV_PARTIC_OUTCOMES VIEW QART MV_PARTIC_INDIV_OFFICE_REF TABLE
QART V_CUBE_INDIV_PARTIC_OUTCOMES VIEW QART MV_PARTIC_INV_SUBJ_OUTCOME TABLE
QART V_CUBE_INDIV_PARTIC_OUTCOMES VIEW QART MV_PARTIC_INVOLVEMENT_REF TABLE
QART V_CUBE_INDIV_PARTIC_OUTCOMES VIEW QART V_CURR_OBJ_STAKEHOLDERS VIEW
QART V_CUBE_INDIV_PARTIC_OUTCOMES VIEW QART MV_PARTIC_INVOLVEMENT TABLE
NAME VALUE
CREATED 05-APR-23
LAST_DDL_TIME 05-FEB-25
OWNER QART
VIEW_NAME V_CUBE_INDIV_PARTIC_OUTCOMES
TEXT_LENGTH 1532
TEXT select distinct           so.sid,           nvl (so.participant, i.participant) as partic_obj,           o1.sid as participant_display,   O2.TAGLINE FILE_CONTEXT,           v1.SH_DISPLAY OWNING_UNIT,           v2.SH_DISPLAY LEAD_DISPLAY,           nvl (ir2.display, ir1.display) as outcome,           case when ir1.parent_row is not null then ir1.display else null end              as outcome_subcategory,           ior.display as office,           io.start_date start_date,           io.end_date end_date,           r.display as employee_type,           so.created_by      from mv_partic_inv_subj_outcome so           left join mv_partic_involvement i              on so.involvement = i.sid           left join mv_acm_obj o1              on so.participant = o1.sid or i.participant = o1.sid   LEFT JOIN MV_ACM_OBJ O2       ON I.OBJ = O2.SID           left join v_curr_obj_stakeholders v1              on i.obj = v1.obj and v1.code = 'OWNING_UNIT'           left join v_curr_obj_stakeholders v2              on i.obj = v2.obj and v2.code = 'LEAD'           left join mv_partic_indiv_office io              on i.indiv_office = io.sid or so.office_assignment = io.sid           left join mv_partic_indiv_office_ref ior              on io.office = ior.ref_key           left join mv_acm_reference r              on io.employee_type = r.ref_key           left join mv_partic_involvement_ref ir1              on so.outcome = ir1.ref_key           left join mv_partic_involvement_ref ir2              on ir1.parent_row = ir2.ref_key
TEXT_VC select distinct           so.sid,           nvl (so.participant, i.participant) as partic_obj,           o1.sid as participant_display,   O2.TAGLINE FILE_CONTEXT,           v1.SH_DISPLAY OWNING_UNIT,           v2.SH_DISPLAY LEAD_DISPLAY,           nvl (ir2.display, ir1.display) as outcome,           case when ir1.parent_row is not null then ir1.display else null end              as outcome_subcategory,           ior.display as office,           io.start_date start_date,           io.end_date end_date,           r.display as employee_type,           so.created_by      from mv_partic_inv_subj_outcome so           left join mv_partic_involvement i              on so.involvement = i.sid           left join mv_acm_obj o1              on so.participant = o1.sid or i.participant = o1.sid   LEFT JOIN MV_ACM_OBJ O2       ON I.OBJ = O2.SID           left join v_curr_obj_stakeholders v1              on i.obj = v1.obj and v1.code = 'OWNING_UNIT'           left join v_curr_obj_stakeholders v2              on i.obj = v2.obj and v2.code = 'LEAD'           left join mv_partic_indiv_office io              on i.indiv_office = io.sid or so.office_assignment = io.sid           left join mv_partic_indiv_office_ref ior              on io.office = ior.ref_key           left join mv_acm_reference r              on io.employee_type = r.ref_key           left join mv_partic_involvement_ref ir1              on so.outcome = ir1.ref_key           left join mv_partic_involvement_ref ir2              on ir1.parent_row = ir2.ref_key
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT